SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031000 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031000 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850866,490454,642095,8301,618052,988231,780701,355808,501439,356372,416159,748712,348625,737148,1022897,747098,174891,196415,336357,144138,991471,1046665,387902,16728,631750,322143,204989,764896,69846,937453,597833,162828,477350,555132,1030205,158987,318396,66228,104253,564908,873553,100910,36384,551814,57878,284552,564972,156859,989435,556575,257372,69592,403778,562063,600072,721657,608773,1028418,570487,215961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002030s ]