SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 978928 LIMIT 1 [ RunTime:0.001138s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 978928 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938121,77043,813433,44102,561344,451796,41023,668247,366230,773714,640794,998360,929517,173092,127186,330755,251948,1000703,214956,666159,831273,950859,282820,706941,140886,794992,910796,347059,382037,537989,709153,997630,181393,652600,1044254,395781,48207,459843,284323,622475,93513,644024,572177,224419,390032,987825,672289,911854,682851,366579,824963,586265,357137,773225,1048507,360146,837675,587774,435956,332032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 978928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 978928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002364s ]