SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392083 LIMIT 1 [ RunTime:0.000659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392083 [ RunTime:0.001283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346932,463061,431676,366345,676319,169272,491121,986400,526943,993200,261877,112390,683306,505556,747895,266328,669648,270264,545900,450982,500942,509088,245851,752885,904076,186433,596056,392077,935190,62949,906113,733499,482140,190832,188147,623626,26669,243233,907432,406393,320479,405595,957562,1014753,550720,819524,908516,474435,175352,1568,653697,39938,67065,643831,1014548,685188,16021,620899,460058,72381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]