SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423328 LIMIT 1 [ RunTime:0.002450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423328 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19416,833025,448188,896464,225688,261156,201947,450908,760077,982726,789102,416323,844253,613513,19198,149487,422863,414249,918932,469639,151877,747351,490916,806572,981114,761178,135464,409872,221290,586379,823418,207759,806269,300707,267713,481404,612124,785859,374155,80075,985205,999788,219793,934670,425928,517717,130676,365192,429053,869498,395163,961220,522660,835623,299051,297286,413029,531923,966716,511205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]