SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357076 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357076 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975694,110956,240184,621794,481948,587101,250068,45510,994708,235968,170564,836222,166165,618897,344100,536645,827782,393995,447641,576851,31737,427268,516881,945111,442099,998979,911981,634427,242330,696201,842552,477248,863220,499918,788507,942986,305837,717248,473546,156230,913113,324285,726146,346244,282363,210297,369202,34690,350282,996167,598526,27233,861011,334440,409347,1014355,986114,913768,468489,611998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002461s ]