SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 208091 LIMIT 1 [ RunTime:0.001313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 208091 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388728,403396,194060,415777,439250,932122,1017340,180910,314416,194471,667393,1029392,72079,968174,797162,229199,1752,244845,664893,757833,277811,230036,723830,162241,702035,910109,944179,521113,536730,532351,894986,290433,703648,508213,141285,83787,342686,622833,535189,605333,106760,88875,370019,188985,806177,368435,416541,184305,299959,234122,365413,754554,231980,163675,53338,769621,220986,430738,85638,756213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 208091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 208091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001149s ]