SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048197 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048197 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88372,802250,378048,342644,238864,39152,949490,152742,147823,681345,542606,516865,468534,595682,836997,832947,443360,209959,989430,322427,296845,968580,447255,663542,38446,979149,421124,658459,986713,88418,3285,830287,384922,978414,940443,17478,902206,283635,463562,180680,281596,101048,173163,694242,698576,590203,461352,409096,689046,18795,397955,1005223,473243,490436,221802,841503,557174,349519,390751,20888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]