SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423376 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423376 [ RunTime:0.002621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627591,993440,622354,495259,642805,1015953,29269,394884,725971,171463,454965,853963,255569,996165,677691,366064,460895,945000,495273,567208,756250,518524,53958,507556,330951,26916,1816,436801,92920,918253,92159,923651,964722,567401,906199,59748,966879,1048643,45888,51500,511914,854948,178529,260032,302342,293855,266622,886591,905659,987522,749308,99594,221536,861591,157028,805274,838050,817485,594841,235687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423376 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423376 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]