SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004661 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004661 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575127,71816,873018,1008525,777496,874056,969550,10862,67053,418700,772943,182503,1008770,464580,788139,255527,307437,231377,779658,472760,963959,600476,367345,895124,603578,286219,589566,756484,889399,1014911,796675,691660,644560,875643,415726,610102,82738,351167,28317,133496,884115,654577,657369,972364,519426,660851,663697,328094,274040,225808,781480,450272,461193,444544,961627,765573,746492,707189,233453,354760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002880s ]