SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342038 LIMIT 1 [ RunTime:0.001781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342038 [ RunTime:0.002909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293473,363180,283360,247574,978110,741749,40060,193608,308216,612632,560434,236738,33285,377115,315054,654340,969393,169577,442417,1012083,284808,385536,181401,199442,759881,658984,660875,2874,443478,20794,11778,768652,374741,238502,544176,570601,561594,60159,545508,203626,659621,737296,164817,319097,623302,888875,346487,625994,136373,159393,557134,486794,220163,498110,684728,194244,822928,1026956,620681,714925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]