SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004158 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004158 [ RunTime:0.004468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989282,449310,421585,421096,751908,994448,462698,417880,624753,859782,146471,251984,585527,304860,321640,21954,649502,1038486,230605,63099,82066,5152,39437,133989,1005881,204575,41978,972904,740732,902138,384385,588129,349078,690077,605566,137191,5612,878677,457565,386383,823614,815444,1042926,478994,88480,877124,226435,27586,472184,809720,834732,58535,176868,661364,233562,339524,398905,1026794,567526,924137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]