SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 160812 LIMIT 1 [ RunTime:0.001674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 160812 [ RunTime:0.002828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196045,47037,614997,220979,486955,677455,365231,774709,18952,672474,98503,864265,952127,282584,684130,700993,112509,289854,123823,640509,369893,295448,994580,7683,70547,22243,241576,192457,931609,857361,501880,387550,249758,859636,525434,251101,887532,552214,417152,704319,267161,828957,947268,580135,293296,966340,1001290,495365,137706,522445,971781,87426,200069,694608,301033,49039,331307,558695,145477,383113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 160812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 160812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]