SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523751 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523751 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558689,127703,257126,485611,679740,225442,864784,4941,160534,182185,150199,138084,886520,190720,165221,828384,773328,101746,83487,117482,666393,390012,230106,502667,865713,574552,766600,325797,418262,1010859,305930,472880,18690,557190,375503,907721,489243,461563,426737,755785,891493,928136,899855,292503,220120,25307,671668,721311,419686,704887,548104,768928,390673,892484,968711,382283,679618,223498,333038,654255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]