SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388781 LIMIT 1 [ RunTime:0.001405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388781 [ RunTime:0.003645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913303,677803,626094,458041,1027865,64301,238895,96040,279597,654899,971564,750800,396527,31216,891407,754392,221448,526119,27974,519989,185053,334397,560842,220722,679636,894227,119645,450397,298357,454395,392038,152015,542366,17265,738949,636594,31093,40324,256290,618353,4513,673559,283596,544632,835854,1021979,960888,368960,346092,809621,212256,393326,363912,577069,770669,291896,360341,429264,719027,1034372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001343s ]