SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813187 LIMIT 1 [ RunTime:0.000632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813187 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470545,779493,1013198,479840,669830,76532,948634,456071,498403,44884,155509,1022503,696188,1033920,499329,349803,312443,172884,740314,899953,976594,530723,888285,744706,160639,783288,499247,600015,277604,1047169,327000,810992,233204,1003108,737647,153183,959724,345522,414344,515064,366974,164557,204544,1019659,234368,447629,486946,904899,627576,678162,716882,385492,992960,4894,442280,210968,339299,436275,1000775,704757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000735s ]