SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30438 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30438 [ RunTime:0.003579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293069,731202,35166,752191,117576,186652,18398,150210,745405,452616,554030,760638,840406,186475,148216,829913,562555,640464,573852,352217,304343,863710,1031488,77182,373218,76081,716407,1010894,536390,609446,601479,826828,422101,277221,971299,671595,989207,567081,605106,786949,243512,401465,1042083,544259,215742,665583,511132,470601,704946,508951,594321,267696,435062,1008299,906951,223242,560588,108373,206554,935219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]