SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 766243 LIMIT 1 [ RunTime:0.001540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 766243 [ RunTime:0.006049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882477,492588,538797,322623,432094,151813,420031,294512,855910,722275,1025914,171691,1038217,422203,375521,261720,898728,63128,447908,481523,298045,759752,440067,608397,630639,259118,936408,46721,1007057,465033,942656,119699,475223,706318,322472,1040744,818737,724294,526646,175993,1044271,954740,1009177,708585,1026680,899147,141667,868442,1024168,444202,80532,1000177,14094,553043,1021739,503217,201739,421534,354848,450237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 766243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 766243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001864s ]