SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010133 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010133 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186956,445852,908973,29090,125416,1028789,194927,414992,719811,90265,1038668,649232,487706,270256,239809,789019,221067,159205,160344,24772,207962,287791,529459,825635,852597,35952,679967,547488,583783,771857,80955,347305,557189,701154,1038844,179910,328237,682395,545982,98135,676488,435712,406567,541057,227320,407297,1044396,12582,254034,107890,751390,252906,773838,906582,652821,100613,778551,909129,643324,707374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]