SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012726 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012726 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545027,732298,106890,900299,113979,44875,300695,854298,768247,968984,1032662,333972,4550,473431,1041531,167748,123094,751600,667686,334746,575059,474918,764532,889698,628275,314810,859226,952398,171156,936485,844030,741819,27167,666507,479060,992517,338728,8699,38367,851832,970027,677962,55448,159588,559079,211414,236756,604867,1011021,730405,793661,995163,978069,378613,575715,326898,959686,1009678,548753,361343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]