SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418370 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418370 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381510,293977,930066,638686,114457,702383,7050,46541,474543,207582,788894,363763,227152,684972,996317,657650,159437,413708,371147,852333,237723,976982,702901,940139,6290,448596,291940,592745,505739,94153,878151,837600,176895,716487,557691,69348,981134,125948,553658,34624,842420,582455,734294,789090,681754,597863,943172,638693,285651,473686,840419,92693,682124,98809,946620,230695,665306,528673,79930,329916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]