SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003428 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003428 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223179,971153,845864,794328,286905,40665,640449,334790,448491,381551,228468,526798,482875,134599,216637,874511,502832,864853,905499,230904,172992,664882,977417,232757,558976,779051,1040442,774452,1043282,762933,107711,88651,171334,132042,611977,910066,947732,367649,818957,331041,68115,167011,232866,697055,973889,973437,598264,619973,501236,532149,390711,550198,193046,12097,314974,223852,1047031,323207,629916,959806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]