SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504515 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504515 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500355,616760,460674,209968,509264,657694,606493,854991,804353,638904,205192,472207,462632,487152,51857,369824,549284,739339,886689,926778,765766,197548,884536,981699,434821,784594,871702,105495,754191,649299,1016223,983837,565286,777030,946193,1032350,694265,254006,1040004,829420,552748,1024801,305030,358286,384414,207116,496856,623317,779287,766246,406050,31598,343937,646829,735404,908709,862824,249186,108693,91620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000794s ]