SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003539 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003539 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438608,431512,626548,876789,200552,262820,885583,869906,166378,415138,825583,736996,223937,301619,908058,616447,170925,935392,216593,360563,832762,451167,938246,290039,362643,184792,471521,519613,116049,290052,691998,644311,22477,792189,811152,693177,361354,320617,47292,993950,110519,852276,569581,731539,741877,791012,282792,371770,803108,265789,643145,20223,97156,755333,598619,357983,678911,989381,183678,440569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]