SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004245 LIMIT 1 [ RunTime:0.002344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004245 [ RunTime:0.001438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752481,218065,153324,980218,788481,623582,605703,554737,759804,147347,615680,119921,634588,50033,670387,507660,913235,489205,406399,882282,605632,436006,835612,1048643,171660,981792,265689,297489,747671,28572,935437,765311,470427,333874,655253,965021,864698,874097,720169,729581,134686,314718,834342,1028574,558588,1026928,1047750,358178,842399,295553,336192,1011803,4797,595301,414663,21707,82158,49368,1015888,916689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]