SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011501 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011501 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482022,862658,394329,653887,520845,596249,579263,55394,555410,206848,167908,271287,936329,379434,643136,553888,860703,224539,1029459,983571,133577,309151,718727,929831,366878,657864,55977,537398,683787,837648,259547,949058,21855,351085,279485,940381,476355,528551,475840,3175,968187,862776,1028630,896640,257061,39928,404001,91493,468330,985452,541932,259515,877537,686839,15678,427740,836149,455428,270797,1030079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001172s ]