SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501499 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501499 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029893,154886,90504,919396,192935,273248,515113,258002,832237,487647,153952,805104,545049,910748,622503,687977,806777,139500,727456,409917,230321,842498,761333,60449,3779,980823,175775,548832,647601,223586,655056,871391,501272,581072,507660,900835,350831,685217,987765,306118,250932,171014,435207,544330,216676,14684,86459,303890,309990,831237,951592,735852,626293,937603,983952,269575,354184,127873,567736,592631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]