SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351514 LIMIT 1 [ RunTime:0.002528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351514 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421684,363755,837683,75908,556641,1026387,793658,319374,772180,414727,465075,46108,719132,57062,864234,61598,950394,358662,490637,730045,817801,22316,88747,392115,876065,445463,298699,258283,332573,1009071,294,299745,807448,860852,679983,120329,304309,958534,888576,1041483,354849,556953,1016453,368317,517854,242321,989234,966458,871060,535892,115573,299859,944192,393971,157316,661536,168678,690743,794306,541341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]