SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522309 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522309 [ RunTime:0.002448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514700,509772,272524,357340,427429,581107,262758,1041069,855516,428444,216215,842807,94043,594351,229151,681568,176230,1015587,1044148,968064,384498,996018,391594,130801,1034134,971241,866186,703754,62604,122241,472065,88265,85908,537715,783282,1515,270255,73035,931820,206288,459798,930381,823,137734,663795,596997,175760,752799,732298,429481,192790,323720,1027399,895620,142215,133166,530964,538979,414553,493021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]