SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020072 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020072 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421198,718504,582677,959773,163269,238778,986110,854836,351647,422562,57030,560715,205729,516667,871048,436559,262781,159065,689616,731362,806752,728831,1014390,29519,965263,817133,940424,839903,98884,430868,319590,188227,904206,166690,612468,89861,814962,676528,372730,787504,863257,161984,232692,114580,699494,252020,1015482,950065,127735,667948,732556,430200,452596,469217,668715,987266,295765,700847,640487,162308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]