SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 911104 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 911104 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457817,896242,846645,421237,695919,149278,755247,706441,751267,1029573,250861,586938,849923,258256,787856,391193,538618,798806,790358,646903,471859,608740,45301,366336,98572,286774,776123,143745,487435,427060,764626,522685,107272,957185,771227,225897,475113,546600,440852,900131,186930,482916,550254,131960,1038971,443520,991285,601131,744272,213750,3078,275044,22916,827271,633501,594972,449702,281589,61428,738247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 911104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 911104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]