SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50363 LIMIT 1 [ RunTime:0.001965s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50363 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950803,982853,441461,791196,162124,119334,710406,942064,877932,1028974,794794,566340,457896,924405,631740,367322,550736,198298,423588,652827,940670,131896,320884,368482,737725,1012046,569985,616001,613046,164781,343360,226202,663878,101035,951458,569416,929588,176644,950970,7039,405481,348023,665596,308324,9036,587722,992040,627411,912207,640601,850865,488304,988546,422170,835790,305178,141218,912216,1029333,253829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50363 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50363 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]