SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245036 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245036 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614883,672465,533584,236299,126590,1000300,509152,248186,796287,156334,775269,186121,682903,961296,425941,1006944,221459,537670,873388,631996,762890,430948,546511,631394,300860,925825,856300,573453,498440,817629,129430,524677,792876,201795,731630,544892,662276,617951,260400,145761,569602,690052,875206,570778,610240,131814,238581,822188,632099,329549,63939,486253,265649,745736,362207,785731,234481,233163,346523,1027960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]