SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567914 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567914 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692223,628390,413429,120521,767328,634734,780658,1034710,609721,752704,516715,502289,968973,422093,405198,177340,587005,203527,307671,1019445,475131,794023,275971,229888,214235,22893,394883,794370,764086,225061,791733,228253,247423,402628,198630,771983,422052,1037230,312775,592638,229708,89807,960565,78068,681562,870879,480987,804910,155524,875255,384008,647390,538445,878760,876261,514979,685449,791727,375886,819520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]