SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298010 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298010 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257296,19865,318653,387494,325179,76457,419531,830760,695717,655831,256991,744499,319774,453320,761972,523680,683032,463184,1044299,431384,776509,918715,432029,681964,61602,565643,170174,515254,226546,476087,735624,245878,341236,301506,857134,617523,449528,657490,571706,611277,394059,534017,745668,363814,643628,112726,353035,140042,337062,450848,757125,92539,428120,89841,804236,867042,6753,862516,343801,226610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]