SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310332 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310332 [ RunTime:0.002875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281080,894808,992356,821583,1008264,79490,430491,1039619,79467,626578,156777,86465,830005,590060,251668,637093,1015035,866238,779728,36311,369921,900382,253957,946811,470576,273842,881915,740470,1014034,878429,377164,987183,812869,896136,856917,54341,242884,787454,182570,575724,444506,629373,519466,270614,156102,464673,181408,615414,800485,1026740,966885,362200,783834,500014,515868,407268,121585,1035317,1007472,191146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]