SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681968 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681968 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333407,454600,430968,331186,1015347,58700,292315,917575,55382,619380,590110,657098,810174,938045,720450,845051,422899,913762,840365,969993,1023177,556952,614562,563713,105477,496794,216199,153520,551724,934308,653391,585023,999892,256438,687912,577480,650967,666009,998369,975998,998772,575281,1013043,655286,580534,535193,327210,825637,776083,180155,369031,750139,718160,804293,218743,905797,122257,448130,798647,265417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001678s ]