SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109543 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109543 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417643,991760,1024057,521948,529293,462653,435000,680801,190037,69762,317895,985974,420330,814605,492583,447363,35598,13662,745826,1021628,949166,226195,281581,1042683,143545,254339,1045431,920248,161011,38116,412408,83844,788978,356963,330297,181033,211134,811279,975496,330439,8223,129059,35583,477244,732192,675438,248916,713107,884528,781466,760301,957533,245777,404794,334028,582747,33644,499656,490543,511962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]