SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402640 LIMIT 1 [ RunTime:0.002118s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402640 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180712,731912,830749,768386,931169,890600,810342,52142,502046,325580,615426,801965,892896,962543,201385,749999,92439,771245,934760,486997,40466,518223,704701,379322,460050,510819,976526,575484,1026623,510994,129022,256511,1014322,124507,902875,851322,27096,900410,78461,458913,408687,658114,671516,94294,111859,864046,465805,512433,986894,756597,15601,293312,632877,280938,25571,897111,198895,409895,218261,290164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]