SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402714 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402714 [ RunTime:0.002291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028279,805008,622608,706696,410861,163920,28516,601503,201360,286187,395349,713035,497265,376013,687161,859284,853964,503170,373427,578222,422203,386108,963562,644503,1004788,303467,571786,410728,926056,34941,726450,319188,822386,450231,167358,633615,471147,107766,734753,987244,764917,712790,141755,96620,224861,730921,704843,385033,171736,516804,359372,107013,878447,417220,110792,1019015,233192,496028,110394,781798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000808s ]