SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402064 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402064 [ RunTime:0.002961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49210,337490,572921,412581,962077,429235,640317,174716,527895,192513,430130,252256,327370,1969,52574,803440,710456,8666,1045270,417314,503801,194500,210089,45393,641660,231033,804507,34592,1012109,129,576662,427966,628644,724121,248598,457000,842094,272289,189815,46849,679158,758482,26073,828090,137889,563882,606555,467052,787704,5971,557031,96769,645647,439336,648539,362650,160487,141064,593618,24585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]