SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147113 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147113 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182957,58067,274049,880984,143080,429052,974055,892365,804898,293470,359559,349759,303320,47436,496669,1046816,433547,633210,822441,834485,339965,756964,805318,326370,257934,39852,404278,301619,67640,640532,692453,62008,811284,872515,653291,75183,915733,127220,810437,850137,328143,785578,892737,357547,455997,603830,293580,478569,358456,650716,444490,84253,185635,1023054,724266,844670,93145,366335,873158,126933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]