SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503984 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503984 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735425,340885,988658,816960,258054,961441,666456,806672,886178,851232,442049,695646,997473,264711,631343,1022366,298966,1000230,126145,473443,995557,344569,529883,410810,626554,1014508,199827,1032685,135658,207621,111501,356617,489028,821749,136595,569465,536259,360405,444576,833707,448174,753909,677916,331877,733359,1033262,847,615307,227815,709400,355650,381255,899190,58644,935187,112404,221980,943468,799465,26088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]