SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584893 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584893 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250101,824927,682452,502853,748815,172096,53657,680539,93021,639463,82564,773057,849567,49006,276672,785012,467947,287496,928554,383365,89662,798771,204873,461310,604654,148624,918741,750636,649680,18111,633318,711288,85480,860242,386993,94569,442290,638614,386154,392410,801384,733281,819915,968583,835791,620904,444972,771899,390378,427907,617713,648263,974326,822089,380499,357740,405561,484801,786601,812271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]