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` = 568266 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568266 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475986,1008310,566200,805974,292184,462513,514674,559525,1015211,454345,379137,111380,561315,419024,44797,538451,804117,894922,116418,641186,106388,661001,153696,574661,318979,978838,857096,136344,642868,930106,951154,727518,498682,929116,18565,864642,894923,1042578,960063,507259,589134,621245,649375,491203,219088,163928,729834,755712,962774,400698,883540,562992,385786,403310,145980,257067,193312,968117,938941,671439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]