SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317438 LIMIT 1 [ RunTime:0.002847s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317438 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703745,50417,516033,94425,856372,581623,365616,13865,110341,692498,823021,634225,236236,709388,620859,575062,1002191,480333,432188,391975,188158,343307,870610,239172,491774,622525,778381,672781,36627,142642,90702,681141,165375,914406,662747,987605,999191,273176,273172,97951,324453,438522,753018,255346,650847,89704,388468,361313,84740,292757,255872,97158,598489,947538,1023171,364239,576758,500176,579448,791583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]