SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017750 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017750 [ RunTime:0.003212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017036,822711,644010,1030094,86177,681934,499030,752996,672049,440715,694102,900526,725615,405450,787330,516181,251372,466238,339523,421510,243151,595714,286823,475290,88284,418403,331299,1016386,79206,230500,832487,254876,952999,381090,70237,967309,745067,264250,676142,910344,798420,365712,98689,747009,238268,222567,972130,128554,276996,9060,1025051,178849,777323,403422,981853,924649,1044568,189647,391388,331831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]