SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396568 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396568 [ RunTime:0.003861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142049,847791,652204,3650,724462,131487,212861,441096,99548,212241,505839,317830,153184,345335,788992,862700,194848,295015,97445,986575,568705,596528,643804,951549,975867,210591,69703,400956,457065,566326,844283,506061,130439,581393,859459,552092,452241,683331,80325,444517,789999,80696,15990,797597,375545,173612,844657,147712,662124,168491,761253,832972,168192,708678,678550,137690,686365,887020,277064,694512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]