SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105150 LIMIT 1 [ RunTime:0.000835s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105150 [ RunTime:0.003195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735004,565361,328669,667119,395146,152076,514045,849897,868368,489811,786842,475054,237139,361913,71222,259256,251455,406092,203796,176683,877348,455001,1047027,296520,568065,505002,636566,541328,994803,1001871,622685,738540,573073,848376,772688,525259,71826,637201,20860,1031192,275426,202012,906145,745196,633025,330890,20536,344876,418568,769913,390076,867019,440250,19817,411809,960023,899722,847236,1037036,960619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000910s ]