SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503734 LIMIT 1 [ RunTime:0.004584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503734 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402249,410093,110749,100084,636381,177390,660358,842029,385849,458717,556020,305835,545129,490633,463446,829910,335569,115375,699979,513375,205511,595319,282528,904114,101630,379466,428023,425846,1003106,571487,927251,14205,407806,713245,327407,644434,355353,695199,603042,380091,1017801,854168,1029371,1018905,1019809,888375,397100,988067,877309,881701,249653,211734,782717,459702,299550,747830,214654,936682,661659,761563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503734 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503734 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001174s ]