SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531802 LIMIT 1 [ RunTime:0.001913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531802 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917101,303288,891200,378776,253712,480305,383930,1041737,634235,71093,300604,451347,2394,1043667,181165,619140,267347,794206,789360,28988,333487,531683,1033427,161358,63249,316006,475838,574496,357726,513624,304835,810560,350774,406170,601113,881535,461524,191367,522307,29634,580288,365006,431757,711417,316476,69355,698603,753117,1013778,699101,632264,817635,478016,1013756,738136,93172,862644,611400,776908,872741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]