SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 762018 LIMIT 1 [ RunTime:0.002150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 762018 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893595,270599,13001,642652,421649,686922,971264,708595,987631,684399,77506,977151,505916,407812,656720,1019948,44663,898833,1008180,406199,443128,669335,656439,555758,99889,720846,116693,13046,900312,854282,887885,223679,982870,811149,852944,673144,149543,146940,606082,273014,253395,732016,1043063,604672,108299,113542,843523,448653,200949,190711,347862,914513,43384,41681,357752,212544,785116,531817,291735,606987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 762018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 762018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004021s ]