SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026426 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026426 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379573,594153,784382,464805,431174,524185,858614,239180,188781,714360,340991,157832,856187,46936,182300,409835,321092,295999,537000,880157,489725,741722,145062,603897,433814,317251,673786,400169,866433,256004,742336,104377,433121,651112,228069,808362,546213,888920,162806,459239,376643,486743,311720,104048,347785,918337,500515,994336,1024659,756323,608928,248510,135310,814083,943337,971279,597876,676630,216812,825773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]