SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456014 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456014 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735719,496218,727946,939850,465882,534707,356760,293613,257394,500684,740821,597213,288999,482456,565108,1034949,493438,595156,900551,593138,919167,538991,622787,168222,454527,63342,631954,125964,461035,144576,86899,164686,201760,323854,510752,165972,356137,1007910,11703,838024,789422,103947,320782,499736,952017,938552,338008,1029982,764847,521556,319372,811984,278719,826496,1001734,186100,745765,164701,1025308,986209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]