SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014393 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014393 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720328,584326,937262,143462,439621,954862,966772,627279,313103,337900,909620,718479,60662,529067,22667,182371,1012323,460799,403052,108408,972733,502202,1028057,348831,26249,148429,310361,95855,275249,261985,120634,714282,276623,786630,952208,498642,621743,413806,1044868,940311,959615,458885,309426,174966,785212,768,622331,375584,957048,179580,364350,652990,881014,15640,931160,95061,44322,245534,746422,939414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001127s ]