SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427927 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427927 [ RunTime:0.002470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847921,980176,559043,585296,156330,257434,834991,458372,617986,176228,126563,218137,151313,110599,906071,894045,618854,151887,383529,125865,935020,93787,393549,946881,376397,189398,353956,719781,86779,984186,935962,553644,420203,263742,934215,170779,384360,717983,379006,836761,36499,593626,269752,216058,318655,1005499,992084,585155,528027,610745,1011054,827254,272714,579679,1013437,253610,423239,794371,514910,187380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]