SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003549s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023652 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023652 [ RunTime:0.004736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911299,586387,1021361,1037259,354648,367244,705102,439999,759612,138287,453103,364118,558821,462875,636950,753700,94787,335299,772291,260072,95584,598389,753672,53507,723252,721511,1041555,461044,871110,573501,638505,630816,9976,384729,753625,67896,150780,903816,22035,858381,256692,104087,593691,218636,344362,323977,527180,182976,260881,715040,176256,213869,210031,782494,403031,999158,645890,152348,970627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]