SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542311 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542311 [ RunTime:0.003363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761103,20428,750195,992737,254746,757963,550283,354756,776349,152197,869602,572086,986432,712245,131104,854305,245720,924884,231250,260602,424972,67931,791503,542682,630525,373429,303264,444776,107817,834735,25765,58574,620006,692876,1015663,255235,565134,445991,328172,443958,255661,850245,305554,410464,298276,507811,113384,4322,244936,97024,21093,1028432,1018943,109014,130975,939784,350886,178045,381001,294241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]