SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451013 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451013 [ RunTime:0.002972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514956,654515,283648,629075,1000358,348059,481297,200893,840189,758870,146997,433868,579291,955924,538187,231252,475097,475546,550809,437586,670402,22811,520598,848867,793932,565265,165660,528235,938407,865604,699874,184329,158889,778744,427888,534320,8125,903385,423340,453602,776748,316106,921511,9929,991666,482447,288692,134249,991297,61861,747535,659706,370475,114450,804318,114265,87328,94298,605314,313937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]