SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520040 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520040 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518230,579296,404068,1028393,464790,837130,959000,103814,491580,589009,461484,129468,543041,392732,875621,143284,737550,715782,1020654,692199,520182,62265,446861,408053,1007621,726930,71771,839404,134187,808323,469563,664501,831070,722253,455394,307169,456103,29221,975965,759122,1000767,233339,332778,155086,365016,265323,874418,944389,97070,778783,875425,37655,84255,166085,58615,260794,406391,827435,89709,1020016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]