SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 14380 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 14380 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78899,608388,31487,108799,429773,844970,285616,268970,34708,889077,73486,180667,89099,446837,361508,834470,267575,134606,133078,20259,47699,128211,987602,956047,409493,477941,303499,255826,717623,233333,1030583,923589,836900,941916,627584,632367,749118,364546,30787,707928,745446,100766,351548,151731,315103,481232,106619,369203,656340,901506,1025805,402489,535632,1031565,6340,672455,585608,194125,1022797,324471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 14380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 14380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001042s ]