SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 856513 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 856513 [ RunTime:0.002511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584426,511500,963465,879280,325129,311051,216450,138721,669743,883678,448459,761249,913067,585333,789356,219127,969719,312864,793244,864850,735336,628677,650852,568211,686594,861578,165777,413087,800553,142393,388160,88125,424421,14439,309974,407859,907963,861217,238955,110350,982077,729453,899886,326919,639358,1034956,200797,923267,985332,192306,531804,635943,904579,880583,1026874,987950,121535,332882,66392,295108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 856513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 856513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]