SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031131 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031131 [ RunTime:0.003414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214091,729588,1031923,21228,477241,970674,134171,224145,247008,1044327,354834,163912,372859,636008,1025291,944171,550578,768149,781820,729412,202789,217518,199749,432267,45839,1034593,659010,369891,430361,229494,117118,81628,322736,986193,86432,373420,293070,220439,474307,256534,676728,707835,521559,505561,515467,378440,579628,783454,105665,443947,1222,1016055,901869,940880,437931,937853,245106,934336,128991,52112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]