SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428933 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428933 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117183,549676,257614,57222,295291,22817,163172,443686,777838,282868,856648,886841,881260,912894,712889,80867,778353,256876,497218,52775,860134,918754,769463,413534,779798,394018,91230,392335,342549,216005,725390,543661,922709,743204,120992,333406,497342,541933,281604,148832,637444,102000,4087,171974,676249,931740,457146,268703,664714,388912,122685,1040406,892748,30118,230253,566816,1006269,850315,226473,870386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]