SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540171 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540171 [ RunTime:0.002990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027781,278473,2637,32552,102284,808448,90353,488026,123107,565857,786024,636968,217397,695750,589256,93462,1005618,758735,768617,26081,594544,755464,468630,1020570,238464,535627,617526,58282,674551,190753,395238,680140,629174,531766,624523,653168,1017999,637712,414505,837303,645963,377057,155329,529842,728030,642264,406868,602464,18582,7407,498609,871484,441534,167246,844709,947966,681357,611345,881054,169529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]