SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403082 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403082 [ RunTime:0.002615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393141,941275,632788,854484,472398,116929,92310,643056,608898,499487,824688,593754,256766,572666,579091,112471,589293,398240,422875,295361,868504,357117,317898,361014,266588,144391,634579,107802,439583,204126,850641,725833,580757,558103,716533,158485,116671,425450,998797,319736,587670,67892,76316,115086,407834,25554,449067,295548,220722,358822,698712,311933,256928,661900,617468,716205,365755,230236,756232,409211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]