SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037856 LIMIT 1 [ RunTime:0.001241s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037856 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189873,917953,187052,1003878,741220,329746,716251,632701,392097,725366,317483,126532,565181,854480,714939,580103,642100,317118,590632,294879,876438,72154,224836,596341,740761,942741,934532,995515,368467,276136,171486,845729,175741,949380,336024,712780,568762,322524,27497,57442,46758,138193,716513,398668,949727,962445,425755,469641,1011166,552890,400633,124650,960272,931526,223803,621515,141883,394115,1020726,13950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]