SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415403 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415403 [ RunTime:0.002393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927047,669030,531936,238107,750831,145600,566765,319566,908006,387592,955183,502436,925056,385129,830217,604066,662228,698348,1029949,573482,297342,88128,888939,117409,91007,255041,141775,327851,487756,487512,154560,889179,869167,144460,63494,855781,546808,692637,396840,602640,789081,193410,976977,530111,596523,166695,980601,502559,407892,713206,523146,98543,644558,203521,753208,572106,676818,348046,344251,669636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]