SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255412 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255412 [ RunTime:0.002356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505814,550208,1027843,603439,247161,387942,75168,960505,229115,544008,1026707,846477,825586,201919,491080,796153,24982,757909,358217,356572,598120,176295,514826,314574,207986,569372,1018640,36349,126847,888969,107267,915121,23676,414142,699533,269424,748583,454353,701377,8814,66582,920215,92783,386843,123997,440465,1004180,315810,199046,157944,553144,134218,806668,303084,979183,286813,1033348,700903,922188,243903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]