SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575240 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575240 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047830,605898,199270,1003007,998739,617095,675952,231000,364454,643445,915193,598760,648325,646405,351176,18894,815088,968035,215320,745566,829213,299384,296856,99201,467577,680449,708835,444022,296145,453020,782025,1041032,775310,365205,736739,775121,167807,411795,471729,302848,163268,597176,428309,568297,832802,418125,584234,158796,422691,479671,705322,16052,590033,796389,402143,895429,85832,660643,854227,1047526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]