SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200459 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200459 [ RunTime:0.002806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34262,263986,551557,349200,980988,47478,553458,417172,150186,599175,322574,731409,1021645,577364,659754,796618,841423,367188,815652,561062,1014700,1046699,920996,734760,903644,639863,36191,1014505,485170,1025075,823129,849362,822924,927926,621814,815087,870427,911881,426515,922682,767634,1033195,709572,687063,471344,620082,520131,52621,32580,727187,86923,100233,871506,709423,193508,361217,657675,945471,623234,705427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200459 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200459 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]