SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456198 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456198 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857718,1045914,94806,730076,1003554,70626,266751,18775,367334,740268,942397,681951,674234,106457,931559,226857,349813,805260,416283,677919,978176,56464,71838,804362,574289,4019,476128,769463,129884,780738,752413,23778,447334,392486,156299,806514,829012,1012859,267972,502376,132384,26461,312458,734495,1015432,618532,985026,1032402,652162,866746,398177,830427,586941,697213,687469,770851,108186,496601,146801,1017867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]