SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 796280 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 796280 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801502,408567,1020512,899208,898945,561365,518523,738223,81039,222750,775879,624735,24707,712552,160810,841702,575224,815683,707498,438007,765961,215812,479512,721739,709187,32126,894717,787518,352531,120109,1010073,126591,214593,970520,970922,657267,912696,1030028,125648,583282,193802,865015,807523,791229,7668,689013,476520,104601,461282,825841,680679,808083,613489,20632,881261,471401,143257,526278,982335,243244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 796280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 796280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]