SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001698s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255447 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255447 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731841,589501,552683,230335,1019945,147327,149143,709643,651884,392236,929761,200718,164581,353915,643008,523776,321235,1040112,63683,342297,1041183,488176,850846,1028077,953729,304210,497794,381714,956180,652913,210837,419875,592249,713408,315554,501418,220681,836305,860749,578373,208061,1042661,791325,848341,424056,829366,408977,985453,813156,232786,318701,541993,801350,32805,326034,608438,924104,73602,975842,290126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]