SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539409 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539409 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972500,554365,675736,880521,933018,5618,344055,471925,615223,3580,264193,399896,343492,632410,858264,772586,953229,303844,898134,379345,117698,554741,772934,994709,496618,450104,427536,1043660,68343,1027638,201857,654873,849612,1027246,159351,474444,2243,329365,628359,97396,85738,94430,970248,623028,332430,323798,804044,749148,516515,900506,472830,546029,334629,903761,481661,319866,314112,106721,132899,287154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]