SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409728 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409728 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326932,1037323,103144,106681,32545,831298,864472,978628,124593,1008279,312194,234937,437622,629751,748084,151173,430524,475729,466021,688720,411144,1035273,20109,136391,211567,129508,168911,956409,475840,809516,458589,426643,103733,561809,168925,348643,840289,529197,828537,528883,838827,312038,616494,400157,534118,646924,1006987,751816,525109,467073,139633,315682,156748,94409,508376,135866,1029507,527623,735835,443451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]