SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045310 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045310 [ RunTime:0.004080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140404,733880,69667,6773,393980,1021788,400269,740571,929153,472032,253325,529128,1045719,157168,436572,711875,324356,411734,448999,163241,921661,988324,154799,119934,4843,698473,295803,806621,145741,678326,115907,955365,355281,216471,1029858,40726,5287,233153,996405,572981,998057,14343,360345,800952,966599,707070,696432,63677,940533,750443,334981,376282,413355,464563,930161,73644,259864,762110,287488,818731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000876s ]