SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400685 LIMIT 1 [ RunTime:0.001688s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400685 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456610,938796,1041613,172405,667980,660340,487850,881958,119166,16349,568540,486407,720744,356941,29147,695961,833802,462582,343480,720511,60654,117569,831464,709756,842002,11777,727096,882377,136362,146928,212409,140311,201507,964764,513357,1032286,489406,709192,514007,107906,697206,893909,891160,901441,667880,617026,483689,32845,817669,1014482,723867,289941,985526,867195,758296,430534,506018,625649,773358,168659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]