SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042723 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042723 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692954,497301,747549,846141,635310,997130,562529,239870,243949,45652,39812,658532,74976,1009350,741224,781921,684680,91650,95874,516146,963043,23856,720808,967551,1020881,964142,64891,334709,839325,934990,55197,159816,949003,64446,675810,134398,958827,515869,508576,654599,1004725,123591,707265,49699,464797,893571,1030938,930867,7197,918569,321357,196920,618769,444040,867511,64669,972055,274665,101529,475752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001487s ]