SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462511 LIMIT 1 [ RunTime:0.000984s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462511 [ RunTime:0.003976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636877,370047,112647,153820,889173,839904,156156,204184,608784,199018,224059,923980,1042562,438130,764878,83712,473330,808,34203,1009072,63169,420968,321082,875567,978681,159734,762299,269101,563293,517443,283837,5171,59713,830837,556618,772716,55436,1017722,270075,1030476,79841,466888,888345,632184,606737,132400,746779,196012,847037,613848,942909,891601,27471,162747,376484,1010352,238753,15330,635500,215599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]